Seamless Reporting Automation through the Integration of JMP, SAS, and VBA
نویسنده
چکیده
The TiVo user interface (UI) is continuously enhanced for design. To monitor and improve UI performance, statistical tests are run on multiple test cases across various dimensions, and weekly reports are generated. The reports require the flexibility of Excel, the analysis power of JMP® and SAS®, and the reporting convenience of PowerPoint. This can be accomplished by integrating JMP, SAS® ODS, and Excel VBA to create an automation tool that seamlessly runs the analyses, conditionally formats the table output, and generates reports in PowerPoint. JMP automates the statistical analysis, SAS® ODS calls Excel VBA macros for the conditional formatting of Excel data sets, and SAS® ODS generates reports in PowerPoint. This paper discusses the tasks involved in the process flow of the automation tool.
منابع مشابه
A SAS/JMP Integration for Implementation of a Clustering Algorithm for High Dimensional Low Sample Size Data
A SAS macro solution is presented for clustering of high dimensional low sample size (HDLLSS) data using a new algorithm based o p-values as similarity measure. The algorithm PPCLUST was developed by von Borries (2008) and implemented using SAS macro language with the macro autocall facility and window macro command for friendly interface. The SAS interface to JMP was used to run a SAS macro in...
متن کاملIncreased Acetate Ester Production of Polyploid Industrial Brewer’s Yeast Strains via Precise and Seamless “Self-cloning” Integration Strategy
Background: Enhancing the industrial yeast strains ethyl acetate yield through a precise and seamless genetic manipulation strategy without any extraneous DNA sequences is an essential requisite and significant demand. Objectives: For increasing the ethyl acetate yield of industrial brewer’s yeast strain, all the ATF1 alleles were overexpressed t...
متن کاملThe Best of Both Worlds: Designing Complex Experiments in the JMP-SAS Environment
Complexity, and supply chains that may expand across the globe, requires us to design experiments that must take into account: 1) the multi-step nature of manufacturing processes, 2) the large number of factors involved, 3) the different sizes of experimental units, 4) the restrictions in randomization that occur, and 5) the constraints in the number of experiments that can be run. Designing ex...
متن کامل02 Pharmacogenomics : JMP ® right in !
The understanding of pharmacogenomics has greatly accelerated in the past decade. With the unraveling of the human genome, the ongoing HAPMAP project and the development of microarray single nucleotide polymorphism (SNP, pronounced “snip”) chips by Affymetrix® and Illumina®, the chore of associating genetic markers with drug reaction states has become a feasible and important project. With the ...
متن کاملEducational data mining using jmp
Educational Data Mining is a growing trend in case of higher education. The quality of the Educational Institute may be enhanced through discovering hidden knowledge from the student databases/ data warehouses. Present paper is designed to carry out a comparative study with the TDC (Three Year Degree) Course students of different colleges affiliated to Dibrugarh University. The study is conduct...
متن کامل